/*******************************************************************************
 * This file is part of blueprint4j www.blueprint4j.org.
 * 
 *     blueprint4j is free software: you can redistribute it and/or modify
 *     it under the terms of the GNU Lesser General Public License as published by
 *     the Free Software Foundation, either version 3 of the License, or
 *     (at your option) any later version.
 * 
 *     blueprint4j is distributed in the hope that it will be useful,
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *     GNU Lesser General Public License for more details.
 * 
 *     You should have received a copy of the GNU Lesser General Public License
 *     along with blueprint4j. If not, see <http://www.gnu.org/licenses/>.
 ******************************************************************************/
package blueprint4j.db;

import java.math.BigDecimal;
import java.math.BigInteger;
import java.text.DateFormat;
import java.text.ParseException;
import java.util.Date;
import java.sql.*;
import java.io.*;

import blueprint4j.utils.*;

public class FieldBlob extends Field {

	/**
	 * public Field( Blob p_name, Blob p_description, boolean p_key_field
	 *
	 * Name: Name of field -> equivalent to table.field_name
	 * Description: Description of field
	 * key_field: Is this field a key field in the table (index field)
	 */
	public FieldBlob( String p_name, int p_field_type ,String p_description,Entity entity ) {
		super( p_name,p_field_type,p_description,entity );
	}

	public Field newInstance(Entity entity) {
		return new FieldBlob(getName(),getFieldType(),getDescription(),entity);
	}

	protected void setFieldValue( ResultSet result_set )
	throws DataException {
		try {
			Blob blob = result_set.getBlob(getName());
			//byte data[] = result_set.getBytes(getName());
			//if (data != null) {
			if (blob != null && blob.length() > 0) {
				//Log.trace.out("FieldBlob","Set Blob size " + blob.length()); 
				byte data[] = blob.getBytes(1,(int)blob.length());
				setObject( data);
			} else {
				setObject(null);
			}
		} catch ( SQLException se ) {
			se.printStackTrace();
			throw new DataException( "Can not retrieve '" + getName() + "'" );
		}
	}

	public byte[] getBlob() {
		return (byte[])(getObject());
	}

	public String toString(){
		if (getObject() == null) {
			return null;
		}
		return ByteM.toString(getBlob());
	}

	public void setBlob(byte value[]){
		setObject(value);
	}

	public void setSQLValue(ResultSet rs) throws SQLException {
		try {
			byte data [] = getObjectAsBytes();
			if (data != null) {
				//rs.updateBytes(getName(),TBase64.encodeBytes(data).getBytes());
				rs.updateBytes(getName(),data);
			} else {
				rs.updateNull(getName());
			}
		} catch (Throwable th) {
			throw new DataException(th);
		}
	}

	/**
	 * This method should be overloaded if child class stores other object than byte[]
	 */
	public byte[] getObjectAsBytes() throws IOException {
		return getBlob();
	}

	/**
	 * Return data in a suitable SQL format
	 */
	public final String getSQLValue()
	throws DataException {
		return "null";
	}

	/*
	 * An overloaded equals method that only accepts the correct type
	 *
	public boolean equals(String value) {
		return getBlob().equals(value);
}*/

	public Object getPreparedStatementObject()
	throws DataException {
		if (getObject() == null) return null;
		return getSQLValue();
	}

	public void setSerializable(String value) throws BindException{
		if ("null".equalsIgnoreCase(""+value)) {
			setObject(null);
		} else {
			setObject(TBase64.decode(value));
		}
	}

	public String getSerializable() throws BindException{
		if (getObject()== null) {
			return "null";
		} else {
			return TBase64.encodeBytes(getBlob());
		}
	}
}
